package com.woniu.woniuproject.mapper;

import com.woniu.woniuproject.entity.LooseLabel;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.Date;
import java.util.List;
@Repository
public interface LooseLabelMapper {
    /**
     * 查询卫审核的散标
     * @param startDate 申请时间范围开始
     * @param endDate  申请时间范围结束
     * @return  未审核的散标
     */
    List<LooseLabel> selectByAplay(@Param("startDate") Date startDate,@Param("endDate") Date endDate,@Param("status") int status);

    int updateStatusByid(@Param("status") int status,@Param("labelid") int labelid);
    @Select("select * from t_loose_label where labelid =#{labelid}")
    LooseLabel selectBykey(int labelid);
}
